*** How To Build EXCEL 5 Example Program *** This test file will describe the steps necessary for building an EXCEL spreadsheet which accesses the serial port. Refer to VBA32.TXT for 32-bit EXCEL (EXCEL 97 and later). (1) Start EXCEL. (2) Choose INSERT, the MACROS, then MODULE. (3) Choose INSERT, FILE, and then select WSC16.BAS from the WSC4VB archive. (4) Move the cursor to the bottom of the file. (5) Choose INSERT, FILE, and then select MODULE.BAS. (6) Change the port (specified in MODULE.BAS) if necessary. (7) Tab back to sheet 1. (8) Move to cell A1, double click, then type =OpenPort() (9) Move to cell A2, double click, then type =PutByte(B2) (10) Move to cell B2, double click, then type 13 (carriage return) (11) Move to cell A3, double click, then type =GetByte() (12) Move to cell A4, double click, then type =ClosePort() (13) Save the completed spreadsheet as EXCEL16.XLS. (14) Test the spreadsheet. [a] Open the serial port by executing cell A1. The Shareware Banner should appear, and a value of 0 returned. [b] Send a byte to the serial port by putting their ascii value (65 for "A", etc.) in cell B2, and executing cell A2. [c] Read bytes from the serial port by executing cell A3. [d] Close the port by executing cell A4.